/* rqlu015.p - GRS Requisitions Ready for Purchase Lookup UI                */
/* Copyright 1986-2002 QAD Inc., Carpinteria, CA, USA.                      */
/* All rights reserved worldwide.  This is an unpublished work.             */
/* $Revision: 1.4 $    */
/*V8:ConvertMode=NoConvert                                                  */
/********************************** History *********************************
 * Revision:     BY: Jean Miller          DATE: 03/04/02  ECO: *N1BS*
 * $Revision: 1.4 $    BY: Katie Hilbert        DATE: 05/09/02  ECO: *P06B*
 ****************************************************************************/

{mfdeclre.i}

&SCOPED-DEFINE BR-TITLE "GRS Requisitions Ready for Purchase"

&SCOPED-DEFINE BR-NAME rq015
&SCOPED-DEFINE Q-DRAG-BACK-COL 1

&SCOPED-DEFINE Q-FIRST-TABLE rqm_mstr
&SCOPED-DEFINE Q-FIRST-FIELD-LIST (rqm_nbr rqm_vend rqm_ship rqm_site rqm_req_date rqm_eby_userid rqm_rqby_userid)
&SCOPED-DEFINE Q-NUM-TABLES 1

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-1 b-1.rqm_nbr
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-1 rqm_mstr.rqm_nbr
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-1 tt-rqm_nbr
&SCOPED-DEFINE BR-K-COL-LABEL-1 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-1 "Order"
&SCOPED-DEFINE BR-FIELD-TYPE-1 character
&SCOPED-DEFINE BR-FIELD-FRMT-1 FORMAT "x(8)"
&SCOPED-DEFINE BR-FIELD-WIDTH-1 9

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-2 b-1.rqm_vend
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-2 rqm_mstr.rqm_vend
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-2 tt-rqm_vend
&SCOPED-DEFINE BR-K-COL-LABEL-2 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-2 "Supplier"
&SCOPED-DEFINE BR-FIELD-TYPE-2 character
&SCOPED-DEFINE BR-FIELD-FRMT-2 FORMAT "x(8)"
&SCOPED-DEFINE BR-FIELD-WIDTH-2 9

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-3 b-1.rqm_ship
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-3 rqm_mstr.rqm_ship
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-3 tt-rqm_ship
&SCOPED-DEFINE BR-K-COL-LABEL-3 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-3 "Ship To"
&SCOPED-DEFINE BR-FIELD-TYPE-3 character
&SCOPED-DEFINE BR-FIELD-FRMT-3 FORMAT "x(8)"
&SCOPED-DEFINE BR-FIELD-WIDTH-3 9

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-4 b-1.rqm_site
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-4 rqm_mstr.rqm_site
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-4 tt-rqm_site
&SCOPED-DEFINE BR-K-COL-LABEL-4 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-4 "Site"
&SCOPED-DEFINE BR-FIELD-TYPE-4 date
&SCOPED-DEFINE BR-FIELD-FRMT-4 FORMAT "x(8)"
&SCOPED-DEFINE BR-FIELD-WIDTH-4 5

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-5 b-1.rqm_req_date
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-5 rqm_mstr.rqm_req_date
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-5 tt-rqm_req_date
&SCOPED-DEFINE BR-K-COL-LABEL-5 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-5 "Rqstn Date"
&SCOPED-DEFINE BR-FIELD-TYPE-5 date
&SCOPED-DEFINE BR-FIELD-FRMT-5 FORMAT "99/99/99"
&SCOPED-DEFINE BR-FIELD-WIDTH-5 11

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-6 b-1.rqm_eby_userid
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-6 rqm_mstr.rqm_eby_userid
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-6 tt-rqm_eby_userid
&SCOPED-DEFINE BR-K-COL-LABEL-6 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-6 "Entered By"
&SCOPED-DEFINE BR-FIELD-TYPE-6 character
&SCOPED-DEFINE BR-FIELD-FRMT-6 FORMAT "x(8)"
&SCOPED-DEFINE BR-FIELD-WIDTH-6 11

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-7 b-1.rqm_rqby_userid
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-7 rqm_mstr.rqm_rqby_userid
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-7 tt-rqm_rqby_userid
&SCOPED-DEFINE BR-K-COL-LABEL-7 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-7 "Requested By"
&SCOPED-DEFINE BR-FIELD-TYPE-7 character
&SCOPED-DEFINE BR-FIELD-FRMT-7 FORMAT "x(8)"
&SCOPED-DEFINE BR-FIELD-WIDTH-7 13

&SCOPED-DEFINE Q-NUM-FILT-VALS 7
&SCOPED-DEFINE BR-MAX-FIELD-WIDTH 13
&SCOPED-DEFINE BR-BROWSE-WIDTH 67
&SCOPED-DEFINE WHERE-CLAUSE rqm_open and rqm_rtdto_purch and rqm_status = ''
&SCOPED-DEFINE BR-INDEXED-FIELDS 1,7

{wbbr01.i &string-4 = 'LOOKUP'}
if c-application-mode <> 'WEB' then do:
   {lookup.i}
end.
